insert overwrite table yl_ods.tab_reback_transfer_express partition(dt)
select
waybill_no
,transfer_waybill_no
,apply_type_code
,apply_type_name
,express_type_id
,express_type_code
,express_type_name
,package_charge_weight
,total_freight
,settlement_code
,settlement_name
,new_package_charge_weight
,new_total_freight
,new_settlement_id
,new_settlement_code
,new_settlement_name
,null as sender_name
,null as sender_mobile_phone
,null as sender_telphone
,sender_province_id
,sender_province_name
,sender_city_id
,sender_city_name
,sender_area_id
,sender_area_name
,sender_township
,sender_street
,null as sender_detailed_address
,null as receiver_name
,null as receiver_mobile_phone
,null as receiver_telphone
,receiver_province_id
,receiver_province_name
,receiver_city_id
,receiver_city_name
,receiver_area_id
,receiver_area_name
,receiver_township
,receiver_street
,null as receiver_detailed_address
,null as new_sender_name
,null as new_sender_mobile_phone
,null as new_sender_telphone
,new_sender_province_id
,new_sender_province_name
,new_sender_city_id
,new_sender_city_name
,new_sender_areaid
,new_sender_areaname
,new_sender_township
,new_sender_street
,null as new_sender_detailed_address
,null as new_receiver_name
,null as new_receiver_mobile_phone
,null as new_receiver_telphone
,new_receiver_province_id
,new_receiver_province_name
,new_receiver_city_id
,new_receiver_city_name
,new_receiver_area_id
,new_receiver_areaname
,new_receiver_township
,newreceiver_street
,null as newreceiver_detailed_address
,abnormal_reg_network_id
,abnormal_reg_network_name
,apply_network_id
,apply_network_code
,apply_network_name
,apply_staff_code
,apply_staff_name
,apply_source
,apply_source_name
,examine_staff_name
,examine_staff_code
,examine_network_id
,examine_network_code
,examine_network_name
,examine_time
,apply_time
,status
,status_name
,reback_transfer_network_id
,reback_transfer_network_code
,reback_transfer_network_name
,sender_network_name
,sender_network_code
,sender_network_id
,print_flag
,print_count
,revoke_code
,revoke_name
,revoke_time
,revoke_network_name
,revoke_network_code
,revoke_network_id
,reject_name
,reject_time
,reason
,reject_network_name
,reject_network_code
,reject_network_id
,entry_type
,transfer_reason
,reback_reason
,reback_transfer_reason
,dispatch_code
,dispatch_name
,goods_type_id
,goods_type_code
,goods_type_name
,parcel_number
,package_length
,package_wide
,package_high
,box_number
,cod_need
,cod_money
,insured
,insured_amount
,print_time
,print_user_name
,print_user_code
,print_user_id
,print_network_name
,print_network_code
,print_network_id
,pick_finance_name
,pick_finance_code
,pick_finance_id
,order_source_code
,customer_order_id
,origin_id
,origin_code
,origin_name
,destination_id
,destination_code
,destination_name
,is_real_name
,real_name
,id_no_type
,id_no
,sex
,customer_id
,customer_code
,customer_name
,send_code
,send_name
,paid_mode_id
,paid_mode_code
,paid_mode_name
,new_insured
,new_insured_amount
,new_terminal_dispatch_code
,is_need_receipt
,apply_network_type_id
,terminal_dispatch_code
,origin_network_flag
,dt
from jms_ods.tab_reback_transfer_express
where dt = '{{ execution_date | cst_ds }}' ;
